2013-05-02 - 4674.1200 - Rel Notes - BI Reports Issues - Release 009 #BIReleases2013
Release Notes:
4674.1200 - BI Reports Issues - OSA172
Admin Info
Purpose
|
To fix the issues in BOBI 4.0 Production server
|
Release No
|
009
|
Submitted
|
05-02-2013
|
Submitted by
|
Praveen Guntuka
|
Source/Destination Systems
|
IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BOBI 4.0 Dev Environment
|
Release Sent To
|
Mark Harris
|
Object(s) Created By
|
Praveen Guntuka
|
Object(s) Tested By
|
Praveen Guntuka
|
Report Name
OSA172 - Open Orders at risk of Cancel
BEx Query
ZSDC_OPN_Q024
NEC Crystal Reports Standards Check
1. OSA172 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. OSA172 NEC CR checklist has been sent to NEC and also attached here for reference:
OSA172 NEC CR Standard Check List.xlsx
Summary Level Check
NOTE : Prior OSA172 report using ZSDC_OPN_Q001 BEx query which is not having Currency conversion fields. So we have created a new Query at database level with the name ZSDC_OPN_Q024 with Currency conversion fields and removed MS Excel currency conversion files from the Crystal Report. Also it was using FiscalPeriod Repository function so we have included the Fiscal Period field at BEx Query end.
Test Conducted
Group: 5th & Ocean Sales
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
No. of Orders
|
14
|
14
|
Pass
|
2
|
Confirmed Qty
|
45,608
|
45,608
|
Pass
|
3
|
Sales Org Currency
|
408,912
|
408,912
|
Pass
|
4
|
Corporate Currency
|
408,912
|
408,912
|
Pass
|
Group: United Stated Sales
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
No. of Orders
|
672
|
672
|
Pass
|
2
|
Confirmed Qty
|
55,941
|
55,941
|
Pass
|
3
|
Sales Org Currency
|
639,172
|
639,172
|
Pass
|
4
|
Corporate Currency
|
639,172
|
639,172
|
Pass
|
Second Level Check
Test Conducted
Group: Australia Sales > Brain O'Meara > March
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
No. of Orders
|
2
|
2
|
Pass
|
2
|
Confirmed Qty
|
14
|
14
|
Pass
|
3
|
Customer Currency
|
378
|
|
|
4
|
Sales Org Currency
|
378
|
378
|
Pass
|
5
|
Corporate Currency
|
394
|
394
|
Pass
|
Group: Mexico Sales > House - HU > April
SNo
|
Test Case
|
Value in Production Report
|
Value in Development Report
|
Pass/Fail
|
1
|
No. of Orders
|
1
|
1
|
Pass
|
2
|
Confirmed Qty
|
3
|
3
|
Pass
|
3
|
Customer Currency
|
694
|
694
|
|
4
|
Sales Org Currency
|
694
|
694
|
Pass
|
5
|
Corporate Currency
|
56
|
56
|
Pass
|
Third Level Check
Test Conducted
Group: Canada Sales > Rob Warren > April > 1400803
SNo
|
Test Case
|
Value in BO 3.1
|
Value in BI 4.0
|
Pass/Fail
|
1
|
Season
|
Stock
|
Stock
|
Pass
|
2
|
Order Date
|
02/15/2013
|
02/15/2013
|
Pass
|
3
|
First Ship
|
04/17/2013
|
04/17/2013
|
Pass
|
4
|
Last Ship
|
04/17/2013
|
04/17/2013
|
Pass
|
5
|
Cancel Date
|
04/20/2013
|
04/20/2013
|
Pass
|
6
|
No. of Orders
|
1
|
1
|
Pass
|
7
|
Confirmed Qty
|
69
|
69
|
Pass
|
8
|
Customer Currency
|
CAD1,301
|
CAD1,301
|
Pass
|
9
|
Company Currency
|
CAD1,301
|
CAD1,301
|
Pass
|
10
|
USD Currency
|
$1280
|
$1280
|
Pass
|
Group: German Sales > Jan Henning > April > 1471295
SNo
|
Test Case
|
Value in BO 3.1
|
Value in BI 4.0
|
Pass/Fail
|
1
|
Season
|
Custom
|
Custom
|
Pass
|
2
|
Order Date
|
04/16/2013
|
04/16/2013
|
Pass
|
3
|
First Ship
|
04/23/2013
|
04/23/2013
|
Pass
|
4
|
Last Ship
|
04/23/2013
|
04/23/2013
|
Pass
|
5
|
Cancel Date
|
12/15/2012
|
12/15/2012
|
Pass
|
6
|
No. of Orders
|
1
|
1
|
Pass
|
7
|
Confirmed Qty
|
20
|
20
|
Pass
|
8
|
Customer Currency
|
118
|
-
|
Pass
|
9
|
Company Currency
|
118
|
118
|
Pass
|
10
|
USD Currency
|
151
|
151
|
Pass
|
Detail Level Check
Test Conducted
Group: EMEA Sales > Gerard Van Der Beek > April > 1294552 > 10812885
SNo
|
Test Case
|
Value in BO 3.1
|
Value in BI 4.0
|
Pass/Fail
|
1
|
Material
|
HEROIC TITLE SUPERMAN OFFICIAL P12
|
MLB BP 5950 SAFGIA 2013 P6
|
Pass
|
2
|
Collection
|
HEROIC TITLE
|
BP PERFORMANCE
|
Pass
|
3
|
Order Status
|
O
|
D
|
Pass
|
4
|
Size
|
B
|
G
|
Pass
|
5
|
Qty
|
12
|
6
|
Pass
|
6
|
UOM
|
EA
|
EA
|
Pass
|
7
|
Unit Price
|
15
|
10.08
|
Pass
|
8
|
Customer Currency
|
184
|
60.45
|
Pass
|
9
|
Company Currency
|
236
|
51.07
|
Pass
|
10
|
USD Currency
|
$77.37
|
$77.37
|
Pass
|
Group: Latin America Sales > Alfredo Alvarez > January > 1209473 > 10740123
SNo
|
Test Case
|
Value in BO 3.1
|
Value in BI 4.0
|
Pass/Fail
|
1
|
Material
|
TPR RUBBER TRI FOLD WALLET BLACK P2
|
ACPERF MIAMAR RD
|
Pass
|
2
|
Collection
|
TRI FOLD WALLETS
|
AC PERFORMANCE
|
Pass
|
3
|
Order Status
|
O
|
I
|
Pass
|
4
|
Size
|
OSFA
|
700
|
Pass
|
5
|
Qty
|
192
|
22
|
Pass
|
6
|
UOM
|
EA
|
EA
|
Pass
|
7
|
Unit Price
|
10
|
2.91
|
Pass
|
8
|
Customer Currency
|
1,882
|
$64.02
|
Pass
|
9
|
Company Currency
|
1,882
|
$64.02
|
Pass
|
10
|
USD Currency
|
1,882
|
$64.02
|
Pass
|
Reference Document(Specification)
2013-04-18 - 4674.1200 - Spec - BI Reports Issues